SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetImageNews]



AS
	/* SET NOCOUNT ON */
	SELECT TOP 3 JOL_Bulletin_No,JOL_Bulletin_Title,JOL_Bulletin_ImageUrl,JOL_Bulletin_Type,JOL_Bulletin_SubType
	FROM dbo.JOL_Bulletin
	WHERE JOL_Bulletin_ImageUrl IS NOT NULL AND  JOL_Bulletin_ImageUrl<>''
	ORDER BY JOL_Bulletin_IsSetTop DESC, JOL_Bulletin_UpdateTime DESC,JOL_Bulletin_AddTime DESC
	
	RETURN
GO
